package com.ysd.twocrm.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ysd.twocrm.entity.StudentProble;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

public interface StudentProbleMapper extends BaseMapper<StudentProble> {

    @Update(value = "update studentproble set spscore=#{spscore},status=#{status} where spid=#{spid}")
    Integer updateProbleExam(Integer spscore,Integer status,Integer spid);
@Select(value = "select * from studentproble where studentid in(select studentid from student where stuclassid=#{stuclassid})")
    List<StudentProble> findAllProbleByStuClassId(Integer stuclassid);
}
